home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 16 / Developer Source Volume 16 (I-MODE Publications, Inc.)(1999).iso / dbprd / dec96 / quinf101.gif < prev    next >
Graphics Interchange Format  |  1998-02-10  |  84KB  |  595x443  |  4-bit (16 colors)
Labels: text | screenshot | diagram | number
OCR: Warehouse Users Warehouse Metadata Tier 0 Tier 1 Tier 2 Tier 3 reach reach through through - staging area -centralized, mostly normalized - centralized, denormalized, and data marts and personal queried directly & reach-through multidimensional structures databases from Tier 2 and Tier 3 structures - queried directly & - queried directly Getting Data Out reach-through from Tier 3 Getting Data In Data Movement Restructure & & Cleansing Denormalize Restructure/ Denormalize/ Copy Data Loads/ Cleansing/ Integrate Internal & External Data FIGURE The four logical tiers of our data warehouse.